﻿CREATE TABLE [dbo].[Goods] (
    [Id]                 UNIQUEIDENTIFIER NOT NULL,
    [SerialNo]           NVARCHAR (36)    NOT NULL,
    [Name]               NVARCHAR (250)   NOT NULL,
    [ShortName]          NVARCHAR (36)    DEFAULT ('') NOT NULL,
    [LastModifiedTime]   DATETIME         NULL,
    [UnitId]             UNIQUEIDENTIFIER NOT NULL,
    [LastModifiedUserID] UNIQUEIDENTIFIER NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK2216C0411E65B0E] FOREIGN KEY ([LastModifiedUserID]) REFERENCES [dbo].[UserProfile] ([ID]),
    CONSTRAINT [FK2216C04F5744A20] FOREIGN KEY ([UnitId]) REFERENCES [dbo].[UOM] ([Id])
);

